namespace CRM.DataAccess.Entities
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("QUOTES")]
    public partial class QUOTE
    {
        public long ID { get; set; }

        [StringLength(50)]
        public string QUOTE_NUMBER { get; set; }

        public bool DELETED { get; set; }

        public long? CREATED_BY { get; set; }

        public DateTime DATE_ENTERED { get; set; }

        public long? MODIFIED_USER_ID { get; set; }

        public DateTime DATE_MODIFIED { get; set; }

        [StringLength(250)]
        public string SUBJECT { get; set; }

        public long? OPPORTUNITY_ID { get; set; }

        public long? QUOTE_STAGE_ID { get; set; }

        public DateTime? VALID_UNTIL { get; set; }

        public long? CONTACT_ID { get; set; }

        public long? CARRIER_ID { get; set; }

        [StringLength(250)]
        public string SHIPPING { get; set; }

        public long? INVENTORY_MANAGER_ID { get; set; }

        public long? ORGANIZATION_ID { get; set; }

        public long? ASSIGNED_TO { get; set; }

        [StringLength(250)]
        public string OFFICE_ADDRESS { get; set; }

        [StringLength(250)]
        public string HOME_ADDRESS { get; set; }

        [StringLength(250)]
        public string OFFICE_PO_BOX { get; set; }

        [StringLength(250)]
        public string HOME_PO_BOX { get; set; }

        [StringLength(50)]
        public string OFFICE_CITY { get; set; }

        [StringLength(50)]
        public string HOME_CITY { get; set; }

        [StringLength(50)]
        public string OFFICE_STATE { get; set; }

        [StringLength(50)]
        public string HOME_STATE { get; set; }

        [StringLength(50)]
        public string OFFICE_POSTAL_CODE { get; set; }

        [StringLength(50)]
        public string HOME_POSTAL_CODE { get; set; }

        [StringLength(50)]
        public string OFFICE_COUNTRY { get; set; }

        [StringLength(50)]
        public string HOME_COUNTRY { get; set; }

        public long? ITEM_ID { get; set; }
    }
}
